Problem Note 63157: The METALIB Procedure returns "ERROR: An exception has been encountered" when you register a table with multiple foreign keys
 |  |  |  |
When you run the METALIB procedure to register a database table to the metadata, you might receive a segmentation violation error. The problem can occur when the table contains several foreign keys with multiple columns.
In this situation, an error similar to the following is written to the SAS® log:
ERROR: An exception has been encountered.
Please contact technical support and provide them with the following
traceback information:
Please contact technical support and provide them with the following
traceback information:
The SAS task name is [METALIB ]
Segmentation Violation
Segmentation Violation
Traceback of the Exception:
/opt/sas/SASFoundation/9.4/sasexe(+0x2d567d) [0x7f8d44e4c67d]
/opt/sas/SASFoundation/9.4/sasexe(+0x2d5613) [0x7f8d44e4c613]
/opt/sas/SASFoundation/9.4/sasexe(+0x8dd68) [0x7f8d44c04d68]
/opt/sas/SASFoundation/9.4/sasexe(+0x8d706) [0x7f8d44c04706]
/opt/sas/SASFoundation/9.4/sasexe/tkmk.so(bkt_signal_handler+0x341)
[0x7f8d42f1ae50]
/lib64/libpthread.so.0(+0x381620f520) [0x7f8d44529520]
/lib64/libc.so.6(memcpy+0xe) [0x7f8d43b5253e]
/opt/sas/SASFoundation/9.4/sasexe/sasmetas(vzml+0x1b7)
[0x7f8d0d5dcfaf]
/opt/sas/SASFoundation/9.4/sasexe/sasmetas(addForKeys+0x568)
[0x7f8d0d5a0095]
/opt/sas/SASFoundation/9.4/sasexe/sasmetas(addmeta+0x2094)
[0x7f8d0d570cc5]
/opt/sas/SASFoundation/9.4/sasexe/sasmetas(refmeta+0x359a)
[0x7f8d0d56815a]
/opt/sas/SASFoundation/9.4/sasexe/sasmetas(sasmetas+0x356f)
[0x7f8d0d54ddab]
/opt/sas/SASFoundation/9.4/sasexe/(vvtentr+0x2d3) [0x7f8d44c04567]
/lib64/libpthread.so.0(+0x38162077e1) [0x7f8d445217e1]
/lib64/libc.so.6(clone+0x6d) [0x7f8d43bb08ed]
/opt/sas/SASFoundation/9.4/sasexe(+0x2d5613) [0x7f8d44e4c613]
/opt/sas/SASFoundation/9.4/sasexe(+0x8dd68) [0x7f8d44c04d68]
/opt/sas/SASFoundation/9.4/sasexe(+0x8d706) [0x7f8d44c04706]
/opt/sas/SASFoundation/9.4/sasexe/tkmk.so(bkt_signal_handler+0x341)
[0x7f8d42f1ae50]
/lib64/libpthread.so.0(+0x381620f520) [0x7f8d44529520]
/lib64/libc.so.6(memcpy+0xe) [0x7f8d43b5253e]
/opt/sas/SASFoundation/9.4/sasexe/sasmetas(vzml+0x1b7)
[0x7f8d0d5dcfaf]
/opt/sas/SASFoundation/9.4/sasexe/sasmetas(addForKeys+0x568)
[0x7f8d0d5a0095]
/opt/sas/SASFoundation/9.4/sasexe/sasmetas(addmeta+0x2094)
[0x7f8d0d570cc5]
/opt/sas/SASFoundation/9.4/sasexe/sasmetas(refmeta+0x359a)
[0x7f8d0d56815a]
/opt/sas/SASFoundation/9.4/sasexe/sasmetas(sasmetas+0x356f)
[0x7f8d0d54ddab]
/opt/sas/SASFoundation/9.4/sasexe/(vvtentr+0x2d3) [0x7f8d44c04567]
/lib64/libpthread.so.0(+0x38162077e1) [0x7f8d445217e1]
/lib64/libc.so.6(clone+0x6d) [0x7f8d43bb08ed]
The problem is caused by the METALIB procedure incorrectly processing its internal list of items that contain key columns for each key constraint.
There is no circumvention for this problem.
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | Base SAS | Solaris for x64 | 9.4 | 9.4_M6 | 9.4 TS1M0 | 9.4 TS1M6 |
| Linux for x64 | 9.4 | 9.4_M6 | 9.4 TS1M0 | 9.4 TS1M6 | ||
| HP-UX IPF | 9.4 | 9.4_M6 | 9.4 TS1M0 | 9.4 TS1M6 | ||
| 64-bit Enabled AIX | 9.4 | 9.4_M6 | 9.4 TS1M0 | 9.4 TS1M6 | ||
| 64-bit Enabled Solaris | 9.4 | 9.4_M6 | 9.4 TS1M0 | 9.4 TS1M6 | ||
| Windows 7 Professional x64 | 9.4 | 9.4_M6 | 9.4 TS1M0 | 9.4 TS1M6 | ||
| Windows 7 Enterprise x64 | 9.4 | 9.4_M6 | 9.4 TS1M0 | 9.4 TS1M6 | ||
| Microsoft Windows Server 2012 Std | 9.4 | 9.4_M6 | 9.4 TS1M0 | 9.4 TS1M6 | ||
| Microsoft Windows Server 2012 R2 Std | 9.4 | 9.4_M6 | 9.4 TS1M0 | 9.4 TS1M6 | ||
| Microsoft Windows Server 2012 R2 Datacenter | 9.4 | 9.4_M6 | 9.4 TS1M0 | 9.4 TS1M6 | ||
| Microsoft Windows Server 2012 Datacenter | 9.4 | 9.4_M6 | 9.4 TS1M0 | 9.4 TS1M6 | ||
| Microsoft Windows Server 2008 for x64 | 9.4 | 9.4 TS1M0 | ||||
| Microsoft Windows Server 2008 R2 | 9.4 | 9.4 TS1M0 | ||||
| Microsoft Windows 10 | 9.4 | 9.4_M6 | 9.4 TS1M0 | 9.4 TS1M6 | ||
| Microsoft Windows 8.1 Pro x64 | 9.4 | 9.4_M6 | 9.4 TS1M0 | 9.4 TS1M6 | ||
| Microsoft Windows 8.1 Pro 32-bit | 9.4 | 9.4_M6 | 9.4 TS1M0 | 9.4 TS1M6 | ||
| Microsoft Windows 8.1 Enterprise x64 | 9.4 | 9.4_M6 | 9.4 TS1M0 | 9.4 TS1M6 | ||
| Microsoft Windows 8.1 Enterprise 32-bit | 9.4 | 9.4_M6 | 9.4 TS1M0 | 9.4 TS1M6 | ||
| Microsoft Windows 8 Pro x64 | 9.4 | 9.4_M6 | 9.4 TS1M0 | 9.4 TS1M6 | ||
| Microsoft Windows 8 Enterprise x64 | 9.4 | 9.4_M6 | 9.4 TS1M0 | 9.4 TS1M6 | ||
| Microsoft® Windows® for x64 | 9.4 | 9.4_M6 | 9.4 TS1M0 | 9.4 TS1M6 | ||
| z/OS | 9.4 | 9.4_M6 | 9.4 TS1M0 | 9.4 TS1M6 | ||
| z/OS 64-bit | 9.4 | 9.4_M6 | 9.4 TS1M0 | 9.4 TS1M6 | ||
| Type: | Problem Note |
| Priority: | medium |
| Date Modified: | 2019-01-29 08:53:18 |
| Date Created: | 2018-11-01 18:22:19 |